Delete Range
AutomatR.Excel.Activities.DeleteRange
The "Delete Range" activity in AutomatR is part of the Excel activities package, specifically designed for deleting a specified range within an Excel workbook. This activity streamlines data manipulation tasks in Excel, enhancing the efficiency of automation workflows.
Properties
| Name | Description |
|---|---|
| Input | |
| Range | Enter the range that needs to be deleted in the workbook sheet (e.g., A5:D4). String variables containing the range. |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Delete Range" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
How to use:
- Drag and drop the "Delete Range" activity onto the workflow.
- Configure the properties by specifying the range to be deleted within the workbook sheet.
- Optionally, configure the delay.
- Execute the workflow to delete the specified range within the Excel workbook.
Example: Consider an example where the "Delete Range" activity is used to delete the range A1:B2 with a 2-second delay:
Delete Range:
Range: "A1:B2"
Delay: 2
In this example, the activity deletes the specified range A1:B2 within the Excel workbook, allowing time for any necessary cleanup or synchronization.